﻿CREATE TABLE [dbo].[user_RoleInfo] (
    [Id]     TINYINT        IDENTITY (1, 1) NOT NULL,
    [Name]   NVARCHAR (128) NOT NULL,
    [Weigth] TINYINT        NOT NULL,
    CONSTRAINT [PK_user_RoleInfo] PRIMARY KEY CLUSTERED ([Id] ASC),
    CONSTRAINT [FK_user_RoleInfo_user_RoleInfo] FOREIGN KEY ([Id]) REFERENCES [dbo].[user_RoleInfo] ([Id])
);


GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_user_RoleInfo_Weigth]
    ON [dbo].[user_RoleInfo]([Weigth] ASC);


GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_user_RoleInfo_Name]
    ON [dbo].[user_RoleInfo]([Name] ASC);

